Data Quality Report

Dataset statistics

Number of variables	26
Number of observations	179
Missing cells	25
Missing cells (%)	0.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	36.5 KiB
Average record size in memory	208.7 B

Variable types

NUM	21
CAT	3
BOOL	2

Warnings

`Num_calls_Cuscare` has constant value "179"	Constant
`Num_of_payments` is highly correlated with `Total_Bills`	High correlation
`Total_Bills` is highly correlated with `Num_of_payments`	High correlation
`Mean_Mthly_Paid_last6mth` is highly correlated with `Mean_Mthly_Paid` and 1 other fields	High correlation
`Mean_Mthly_Paid` is highly correlated with `Mean_Mthly_Paid_last6mth`	High correlation
`Total_Paid_last6mth` is highly correlated with `Mean_Mthly_Paid_last6mth`	High correlation
`Num_Payments_last6mth` is highly correlated with `Total_Bills_last6mth` and 1 other fields	High correlation
`Total_Bills_last6mth` is highly correlated with `Num_Payments_last6mth` and 1 other fields	High correlation
`Delayed_Partial_Payments_last6mth` is highly correlated with `Total_Bills_last6mth` and 1 other fields	High correlation
`avg_Data_last6mth` is highly correlated with `avg_Data`	High correlation
`avg_Data` is highly correlated with `avg_Data_last6mth`	High correlation
`Age` has 9 (5.0%) missing values	Missing
`LocID` has 3 (1.7%) missing values	Missing
`Mean_Mthly_Paid` has 2 (1.1%) missing values	Missing
`Mean_Mthly_Paid_last6mth` has 3 (1.7%) missing values	Missing
`ttl_Data` has 2 (1.1%) missing values	Missing
`Cust_id` has unique values	Unique
`avg_Data_last6mth` has unique values	Unique
`avg_online_days` has unique values	Unique
`Timely_full_payments` has 4 (2.2%) zeros	Zeros
`Timely_Full_Payments_last6mth` has 7 (3.9%) zeros	Zeros
`Delayed_Partial_Payments_last6mth` has 61 (34.1%) zeros	Zeros

Reproduction

Analysis started	2021-01-20 06:33:29.649982
Analysis finished	2021-01-20 06:36:05.182388
Duration	2 minutes and 35.53 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

Cust_id
Real number (ℝ_≥0)

UNIQUE

Distinct	179
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	90
Minimum	1
Maximum	179
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 KiB

Quantile statistics

Minimum	1
5-th percentile	9.9
Q1	45.5
median	90
Q3	134.5
95-th percentile	170.1
Maximum	179
Range	178
Interquartile range (IQR)	89

Descriptive statistics

Standard deviation	51.81698563
Coefficient of variation (CV)	0.5757442848
Kurtosis	-1.2
Mean	90
Median Absolute Deviation (MAD)	45
Skewness	0
Sum	16110
Variance	2685
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	0.6%
135	1	0.6%
115	1	0.6%
116	1	0.6%
117	1	0.6%
118	1	0.6%
119	1	0.6%
120	1	0.6%
121	1	0.6%
122	1	0.6%
Other values (169)	169	94.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	0.6%
2	1	0.6%
3	1	0.6%
4	1	0.6%
5	1	0.6%

Value	Count	Frequency (%)
179	1	0.6%
178	1	0.6%
177	1	0.6%
176	1	0.6%
175	1	0.6%

Age
Real number (ℝ_≥0)

MISSING

Distinct	43
Distinct (%)	25.3%
Missing	9
Missing (%)	5.0%
Infinite	0
Infinite (%)	0.0%

Mean	36.50588235
Minimum	19
Maximum	75
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 KiB

Quantile statistics

Minimum	19
5-th percentile	20.45
Q1	26
median	33
Q3	46
95-th percentile	58
Maximum	75
Range	56
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	12.98713385
Coefficient of variation (CV)	0.3557545528
Kurtosis	-0.08207201354
Mean	36.50588235
Median Absolute Deviation (MAD)	9
Skewness	0.7383578214
Sum	6206
Variance	168.6656457
Monotocity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
24	8	4.5%
32	8	4.5%
26	8	4.5%
21	8	4.5%
38	7	3.9%
48	7	3.9%
27	7	3.9%
20	7	3.9%
25	6	3.4%
46	6	3.4%
Other values (33)	98	54.7%
(Missing)	9	5.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
19	2	1.1%
20	7	3.9%
21	8	4.5%
22	5	2.8%
23	5	2.8%

Value	Count	Frequency (%)
75	1	0.6%
73	1	0.6%
70	2	1.1%
69	1	0.6%
67	1	0.6%

LocID
Real number (ℝ_≥0)

MISSING

Distinct	14
Distinct (%)	8.0%
Missing	3
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%

Mean	237.7215909
Minimum	231
Maximum	265
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 KiB

Quantile statistics

Minimum	231
5-th percentile	231
Q1	232
median	237
Q3	240
95-th percentile	249.25
Maximum	265
Range	34
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	7.515833935
Coefficient of variation (CV)	0.03161611828
Kurtosis	6.391939252
Mean	237.7215909
Median Absolute Deviation (MAD)	4.5
Skewness	2.349974308
Sum	41839
Variance	56.48775974
Monotocity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
231	34	19.0%
238	24	13.4%
242	20	11.2%
232	15	8.4%
237	15	8.4%
236	15	8.4%
244	10	5.6%
235	9	5.0%
265	9	5.0%
234	9	5.0%
Other values (4)	16	8.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
231	34	19.0%
232	15	8.4%
233	4	2.2%
234	9	5.0%
235	9	5.0%

Value	Count	Frequency (%)
265	9	5.0%
244	10	5.6%
242	20	11.2%
241	2	1.1%
240	8	4.5%

GenID
Categorical

Distinct	2
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 KiB

1	101
2	78

Frequencies
Length

Value	Count	Frequency (%)
1	101	56.4%
2	78	43.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

RaceID
Categorical

Distinct	4
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Memory size	1.4 KiB

1	100
2	50
3	15
4	14

Frequencies
Length

Value	Count	Frequency (%)
1	100	55.9%
2	50	27.9%
3	15	8.4%
4	14	7.8%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

PkgID
Real number (ℝ_≥0)

Distinct	34
Distinct (%)	19.1%
Missing	1
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%

Mean	123.5674157
Minimum	1
Maximum	273
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	10
median	197
Q3	227
95-th percentile	227
Maximum	273
Range	272
Interquartile range (IQR)	217

Descriptive statistics

Standard deviation	101.1814305
Coefficient of variation (CV)	0.8188358546
Kurtosis	-1.900285423
Mean	123.5674157
Median Absolute Deviation (MAD)	57
Skewness	-0.08845522706
Sum	21995
Variance	10237.68187
Monotocity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
227	53	29.6%
197	23	12.8%
10	19	10.6%
9	15	8.4%
6	6	3.4%
11	6	3.4%
14	5	2.8%
89	5	2.8%
45	4	2.2%
5	4	2.2%
Other values (24)	38	21.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	0.6%
3	1	0.6%
5	4	2.2%
6	6	3.4%
7	1	0.6%

Value	Count	Frequency (%)
273	1	0.6%
260	1	0.6%
254	2	1.1%
227	53	29.6%
224	3	1.7%

CusCare_flag
Categorical

Distinct	1
Distinct (%)	0.6%
Missing	1
Missing (%)	0.6%
Memory size	1.4 KiB

No	178

Frequencies
Length

Value	Count	Frequency (%)
No	178	99.4%
(Missing)	1	0.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	2
Mean length	2.005586592
Min length	2

Num_calls_Cuscare
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1.4 KiB

0	179

Common Values
Chart

Value	Count	Frequency (%)
0	179	100.0%

BillCycle_ID
Real number (ℝ_≥0)

Distinct	10
Distinct (%)	5.6%
Missing	1
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%

Mean	4.758426966
Minimum	1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	5
Q3	7
95-th percentile	9
Maximum	10
Range	9
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.556273284
Coefficient of variation (CV)	0.5372097339
Kurtosis	-0.8169690084
Mean	4.758426966
Median Absolute Deviation (MAD)	2
Skewness	0.2379863144
Sum	847
Variance	6.534533105
Monotocity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
5	27	15.1%
4	24	13.4%
7	23	12.8%
1	23	12.8%
2	19	10.6%
6	19	10.6%
3	18	10.1%
9	12	6.7%
10	7	3.9%
8	6	3.4%
(Missing)	1	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	23	12.8%
2	19	10.6%
3	18	10.1%
4	24	13.4%
5	27	15.1%

Value	Count	Frequency (%)
10	7	3.9%
9	12	6.7%
8	6	3.4%
7	23	12.8%
6	19	10.6%

Mean_Mthly_Paid
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	176
Distinct (%)	99.4%
Missing	2
Missing (%)	1.1%
Infinite	0
Infinite (%)	0.0%

Mean	94.36887006
Minimum	48.4
Maximum	213.75
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 KiB

Quantile statistics

Minimum	48.4
5-th percentile	59.486
Q1	74.77
median	91.67
Q3	107.03
95-th percentile	142.04
Maximum	213.75
Range	165.35
Interquartile range (IQR)	32.26

Descriptive statistics

Standard deviation	27.46762743
Coefficient of variation (CV)	0.2910666135
Kurtosis	3.065647596
Mean	94.36887006
Median Absolute Deviation (MAD)	16.5
Skewness	1.205964951
Sum	16703.29
Variance	754.4705567
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
84.48	2	1.1%
75.15	1	0.6%
100.82	1	0.6%
114.75	1	0.6%
93.25	1	0.6%
141.8	1	0.6%
93.92	1	0.6%
89.89	1	0.6%
110.94	1	0.6%
63.15	1	0.6%
Other values (166)	166	92.7%
(Missing)	2	1.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
48.4	1	0.6%
50.07	1	0.6%
51.79	1	0.6%
51.93	1	0.6%
52.28	1	0.6%

Value	Count	Frequency (%)
213.75	1	0.6%
213.56	1	0.6%
174.01	1	0.6%
161.73	1	0.6%
152.95	1	0.6%

Total_Bills
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	39
Distinct (%)	21.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	16.53072626
Minimum	3
Maximum	58
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 KiB

Quantile statistics

Minimum	3
5-th percentile	5
Q1	8
median	14
Q3	23
95-th percentile	36
Maximum	58
Range	55
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	10.40164772
Coefficient of variation (CV)	0.6292311396
Kurtosis	1.435936869
Mean	16.53072626
Median Absolute Deviation (MAD)	7
Skewness	1.111773414
Sum	2959
Variance	108.1942753
Monotocity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
6	14	7.8%
5	11	6.1%
11	11	6.1%
7	10	5.6%
9	9	5.0%
12	9	5.0%
13	8	4.5%
24	6	3.4%
10	6	3.4%
20	6	3.4%
Other values (29)	89	49.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	2	1.1%
4	5	2.8%
5	11	6.1%
6	14	7.8%
7	10	5.6%

Value	Count	Frequency (%)
58	1	0.6%
56	1	0.6%
42	1	0.6%
40	2	1.1%
39	1	0.6%

Num_of_payments
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	39
Distinct (%)	21.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	16.53072626
Minimum	3
Maximum	58
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 KiB

Quantile statistics

Minimum	3
5-th percentile	5
Q1	8
median	14
Q3	23
95-th percentile	36
Maximum	58
Range	55
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	10.40164772
Coefficient of variation (CV)	0.6292311396
Kurtosis	1.435936869
Mean	16.53072626
Median Absolute Deviation (MAD)	7
Skewness	1.111773414
Sum	2959
Variance	108.1942753
Monotocity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
6	14	7.8%
5	11	6.1%
11	11	6.1%
7	10	5.6%
9	9	5.0%
12	9	5.0%
13	8	4.5%
24	6	3.4%
10	6	3.4%
20	6	3.4%
Other values (29)	89	49.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	2	1.1%
4	5	2.8%
5	11	6.1%
6	14	7.8%
7	10	5.6%

Value	Count	Frequency (%)
58	1	0.6%
56	1	0.6%
42	1	0.6%
40	2	1.1%
39	1	0.6%

Timely_full_payments
Real number (ℝ_≥0)

ZEROS

Distinct	31
Distinct (%)	17.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	9.687150838
Minimum	0
Maximum	36
Zeros	4
Zeros (%)	2.2%
Memory size	1.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	4
median	8
Q3	13
95-th percentile	23.1
Maximum	36
Range	36
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	7.481242629
Coefficient of variation (CV)	0.7722851388
Kurtosis	2.036852929
Mean	9.687150838
Median Absolute Deviation (MAD)	4
Skewness	1.408672776
Sum	1734
Variance	55.96899127
Monotocity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
3	19	10.6%
4	15	8.4%
6	14	7.8%
9	14	7.8%
5	13	7.3%
7	11	6.1%
8	9	5.0%
10	9	5.0%
11	8	4.5%
20	6	3.4%
Other values (21)	61	34.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4	2.2%
1	6	3.4%
2	5	2.8%
3	19	10.6%
4	15	8.4%

Value	Count	Frequency (%)
36	1	0.6%
35	1	0.6%
34	2	1.1%
33	1	0.6%
31	1	0.6%

Delayed_Partial_Payments
Real number (ℝ_≥0)

Distinct	25
Distinct (%)	14.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6.843575419
Minimum	1
Maximum	55
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	8
95-th percentile	22.2
Maximum	55
Range	54
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	7.66563179
Coefficient of variation (CV)	1.12012089
Kurtosis	11.00628776
Mean	6.843575419
Median Absolute Deviation (MAD)	2
Skewness	2.867689194
Sum	1225
Variance	58.76191074
Monotocity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
2	29	16.2%
3	24	13.4%
1	22	12.3%
4	20	11.2%
5	13	7.3%
6	12	6.7%
7	9	5.0%
10	9	5.0%
8	7	3.9%
12	5	2.8%
Other values (15)	29	16.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	22	12.3%
2	29	16.2%
3	24	13.4%
4	20	11.2%
5	13	7.3%

Value	Count	Frequency (%)
55	1	0.6%
36	1	0.6%
35	2	1.1%
29	1	0.6%
27	1	0.6%

Total_Paid_last6mth
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	156
Distinct (%)	87.6%
Missing	1
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%

Mean	523.6611236
Minimum	244.08
Maximum	1174.5
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 KiB

Quantile statistics

Minimum	244.08
5-th percentile	304.195
Q1	421
median	500.375
Q3	593.375
95-th percentile	818.872
Maximum	1174.5
Range	930.42
Interquartile range (IQR)	172.375

Descriptive statistics

Standard deviation	162.7581175
Coefficient of variation (CV)	0.3108080975
Kurtosis	2.853567191
Mean	523.6611236
Median Absolute Deviation (MAD)	82
Skewness	1.318148157
Sum	93211.68
Variance	26490.20483
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
402.6	5	2.8%
502.5	3	1.7%
566.1	3	1.7%
432.6	3	1.7%
447.43	2	1.1%
305.4	2	1.1%
500	2	1.1%
432	2	1.1%
490	2	1.1%
647	2	1.1%
Other values (146)	152	84.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
244.08	1	0.6%
255.4	1	0.6%
261.05	1	0.6%
268.88	1	0.6%
277.95	1	0.6%

Value	Count	Frequency (%)
1174.5	1	0.6%
1164	1	0.6%
1044.03	1	0.6%
1009	1	0.6%
1002	1	0.6%

Mean_Mthly_Paid_last6mth
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	158
Distinct (%)	89.8%
Missing	3
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%

Mean	91.92340909
Minimum	42.57
Maximum	213.75
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 KiB

Quantile statistics

Minimum	42.57
5-th percentile	52.055
Q1	71.585
median	87.405
Q3	107.915
95-th percentile	144.385
Maximum	213.75
Range	171.18
Interquartile range (IQR)	36.33

Descriptive statistics

Standard deviation	29.39991518
Coefficient of variation (CV)	0.3198305575
Kurtosis	2.486447708
Mean	91.92340909
Median Absolute Deviation (MAD)	17.48
Skewness	1.250733505
Sum	16178.52
Variance	864.3550123
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
67.1	5	2.8%
83.75	3	1.7%
72.1	3	1.7%
94.35	3	1.7%
72	2	1.1%
110	2	1.1%
65.13	2	1.1%
94.33	2	1.1%
110.08	2	1.1%
69.75	2	1.1%
Other values (148)	150	83.8%
(Missing)	3	1.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
42.57	1	0.6%
43.51	1	0.6%
46.33	1	0.6%
47.57	1	0.6%
47.6	1	0.6%

Value	Count	Frequency (%)
213.75	1	0.6%
195.75	1	0.6%
194	1	0.6%
174.01	1	0.6%
168.17	1	0.6%

Total_Bills_last6mth
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	15
Distinct (%)	8.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6.346368715
Minimum	3
Maximum	20
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 KiB

Quantile statistics

Minimum	3
5-th percentile	3
Q1	5
median	6
Q3	7
95-th percentile	12
Maximum	20
Range	17
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.949504948
Coefficient of variation (CV)	0.4647547409
Kurtosis	8.250044488
Mean	6.346368715
Median Absolute Deviation (MAD)	1
Skewness	2.575858576
Sum	1136
Variance	8.699579436
Monotocity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
6	56	31.3%
5	40	22.3%
4	23	12.8%
7	21	11.7%
3	11	6.1%
8	7	3.9%
11	4	2.2%
9	3	1.7%
10	3	1.7%
12	3	1.7%
Other values (5)	8	4.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	11	6.1%
4	23	12.8%
5	40	22.3%
6	56	31.3%
7	21	11.7%

Value	Count	Frequency (%)
20	3	1.7%
18	1	0.6%
15	2	1.1%
14	1	0.6%
13	1	0.6%

Num_Payments_last6mth
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	15
Distinct (%)	8.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6.346368715
Minimum	3
Maximum	20
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 KiB

Quantile statistics

Minimum	3
5-th percentile	3
Q1	5
median	6
Q3	7
95-th percentile	12
Maximum	20
Range	17
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.949504948
Coefficient of variation (CV)	0.4647547409
Kurtosis	8.250044488
Mean	6.346368715
Median Absolute Deviation (MAD)	1
Skewness	2.575858576
Sum	1136
Variance	8.699579436
Monotocity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
6	56	31.3%
5	40	22.3%
4	23	12.8%
7	21	11.7%
3	11	6.1%
8	7	3.9%
11	4	2.2%
9	3	1.7%
10	3	1.7%
12	3	1.7%
Other values (5)	8	4.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	11	6.1%
4	23	12.8%
5	40	22.3%
6	56	31.3%
7	21	11.7%

Value	Count	Frequency (%)
20	3	1.7%
18	1	0.6%
15	2	1.1%
14	1	0.6%
13	1	0.6%

Timely_Full_Payments_last6mth
Real number (ℝ_≥0)

ZEROS

Distinct	8
Distinct (%)	4.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.955307263
Minimum	0
Maximum	7
Zeros	7
Zeros (%)	3.9%
Memory size	1.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	3
median	4
Q3	5
95-th percentile	6
Maximum	7
Range	7
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.627782765
Coefficient of variation (CV)	0.4115439477
Kurtosis	-0.229093939
Mean	3.955307263
Median Absolute Deviation (MAD)	1
Skewness	-0.5041761163
Sum	708
Variance	2.649676731
Monotocity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
4	45	25.1%
6	36	20.1%
3	35	19.6%
5	31	17.3%
2	15	8.4%
1	8	4.5%
0	7	3.9%
7	2	1.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7	3.9%
1	8	4.5%
2	15	8.4%
3	35	19.6%
4	45	25.1%

Value	Count	Frequency (%)
7	2	1.1%
6	36	20.1%
5	31	17.3%
4	45	25.1%
3	35	19.6%

Delayed_Partial_Payments_last6mth
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	17
Distinct (%)	9.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.391061453
Minimum	0
Maximum	20
Zeros	61
Zeros (%)	34.1%
Memory size	1.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	10
Maximum	20
Range	20
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	3.769053243
Coefficient of variation (CV)	1.576309651
Kurtosis	8.325083222
Mean	2.391061453
Median Absolute Deviation (MAD)	1
Skewness	2.762801811
Sum	428
Variance	14.20576235
Monotocity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	61	34.1%
1	39	21.8%
2	35	19.6%
3	12	6.7%
4	8	4.5%
10	6	3.4%
5	3	1.7%
6	3	1.7%
9	2	1.1%
8	2	1.1%
Other values (7)	8	4.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	61	34.1%
1	39	21.8%
2	35	19.6%
3	12	6.7%
4	8	4.5%

Value	Count	Frequency (%)
20	2	1.1%
19	1	0.6%
17	1	0.6%
15	1	0.6%
14	1	0.6%

ttl_Data
Real number (ℝ_≥0)

MISSING

Distinct	177
Distinct (%)	100.0%
Missing	2
Missing (%)	1.1%
Infinite	0
Infinite (%)	0.0%

Mean	150330.8318
Minimum	5065.09
Maximum	854484.75
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 KiB

Quantile statistics

Minimum	5065.09
5-th percentile	15604.876
Q1	48806.74
median	107352.28
Q3	166583.25
95-th percentile	468332.15
Maximum	854484.75
Range	849419.66
Interquartile range (IQR)	117776.51

Descriptive statistics

Standard deviation	156184.8351
Coefficient of variation (CV)	1.038940803
Kurtosis	5.713148828
Mean	150330.8318
Median Absolute Deviation (MAD)	59230.97
Skewness	2.253109386
Sum	26608557.23
Variance	2.43937027e+10
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
112647.36	1	0.6%
69359.13	1	0.6%
134121.62	1	0.6%
255797.36	1	0.6%
23016.94	1	0.6%
168506.2	1	0.6%
152169.34	1	0.6%
64188.83	1	0.6%
102205.13	1	0.6%
30479.05	1	0.6%
Other values (167)	167	93.3%
(Missing)	2	1.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5065.09	1	0.6%
6006.74	1	0.6%
8392.14	1	0.6%
8543.55	1	0.6%
8580.13	1	0.6%

Value	Count	Frequency (%)
854484.75	1	0.6%
812471.68	1	0.6%
744756.2	1	0.6%
694534.44	1	0.6%
676699.16	1	0.6%

avg_Data
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	178
Distinct (%)	100.0%
Missing	1
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%

Mean	13221.78202
Minimum	1067.94
Maximum	68781.43
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 KiB

Quantile statistics

Minimum	1067.94
5-th percentile	2011.6
Q1	4824.2975
median	7468.375
Q3	16053.7575
95-th percentile	44710.36
Maximum	68781.43
Range	67713.49
Interquartile range (IQR)	11229.46

Descriptive statistics

Standard deviation	13855.97624
Coefficient of variation (CV)	1.047965865
Kurtosis	3.470324762
Mean	13221.78202
Median Absolute Deviation (MAD)	3954.455
Skewness	1.940895081
Sum	2353477.2
Variance	191988077.5
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4919.16	1	0.6%
3964.47	1	0.6%
6327.51	1	0.6%
2140.35	1	0.6%
17659.49	1	0.6%
58598.17	1	0.6%
6187.96	1	0.6%
7264.9	1	0.6%
16047.21	1	0.6%
55542.07	1	0.6%
Other values (168)	168	93.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1067.94	1	0.6%
1198.88	1	0.6%
1322.72	1	0.6%
1450.86	1	0.6%
1451.8	1	0.6%

Value	Count	Frequency (%)
68781.43	1	0.6%
63139.49	1	0.6%
58598.17	1	0.6%
58031.57	1	0.6%
55542.07	1	0.6%

ttl_Data_last6mth
Real number (ℝ_≥0)

Distinct	178
Distinct (%)	100.0%
Missing	1
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%

Mean	491615.1369
Minimum	1712.4
Maximum	7031645.78
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 KiB

Quantile statistics

Minimum	1712.4
5-th percentile	7638.4595
Q1	21906.96
median	43028.3
Q3	402719.2575
95-th percentile	2671788.343
Maximum	7031645.78
Range	7029933.38
Interquartile range (IQR)	380812.2975

Descriptive statistics

Standard deviation	1010219.936
Coefficient of variation (CV)	2.054899982
Kurtosis	12.97505033
Mean	491615.1369
Median Absolute Deviation (MAD)	28797.245
Skewness	3.235905767
Sum	87507494.36
Variance	1.020544319e+12
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19648.54	1	0.6%
719167.66	1	0.6%
6233.01	1	0.6%
10288.77	1	0.6%
23417.19	1	0.6%
16523.14	1	0.6%
1288762.95	1	0.6%
42460.06	1	0.6%
99271.7	1	0.6%
793055.98	1	0.6%
Other values (168)	168	93.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1712.4	1	0.6%
2264.75	1	0.6%
2774.37	1	0.6%
3804.54	1	0.6%
4412.6	1	0.6%

Value	Count	Frequency (%)
7031645.78	1	0.6%
4713759	1	0.6%
4563988.25	1	0.6%
3698790.34	1	0.6%
3355329.49	1	0.6%

avg_Data_last6mth
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	179
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	12284.67034
Minimum	377.46
Maximum	58882.16
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 KiB

Quantile statistics

Minimum	377.46
5-th percentile	1383.46
Q1	3914.2
median	7123.5
Q3	16601.815
95-th percentile	38335.629
Maximum	58882.16
Range	58504.7
Interquartile range (IQR)	12687.615

Descriptive statistics

Standard deviation	12272.69657
Coefficient of variation (CV)	0.9990253084
Kurtosis	2.498878936
Mean	12284.67034
Median Absolute Deviation (MAD)	3944.11
Skewness	1.713735606
Sum	2198955.99
Variance	150619081.1
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3902.41	1	0.6%
8245.34	1	0.6%
3179.39	1	0.6%
7344.42	1	0.6%
7952.3	1	0.6%
38112.35	1	0.6%
41236.17	1	0.6%
36262.65	1	0.6%
12651.44	1	0.6%
21852.56	1	0.6%
Other values (169)	169	94.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
377.46	1	0.6%
634.09	1	0.6%
735.43	1	0.6%
856.2	1	0.6%
1038.83	1	0.6%

Value	Count	Frequency (%)
58882.16	1	0.6%
54117.73	1	0.6%
53270.04	1	0.6%
49101.66	1	0.6%
48416.99	1	0.6%

avg_online_days
Real number (ℝ_≥0)

UNIQUE

Distinct	179
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	12.48642797
Minimum	11.0036187
Maximum	16.06159477
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 KiB

Quantile statistics

Minimum	11.0036187
5-th percentile	11.23457152
Q1	11.81351909
median	12.44995326
Q3	12.97033829
95-th percentile	14.09849872
Maximum	16.06159477
Range	5.05797607
Interquartile range (IQR)	1.1568192

Descriptive statistics

Standard deviation	0.9569838625
Coefficient of variation (CV)	0.07664192389
Kurtosis	2.625048406
Mean	12.48642797
Median Absolute Deviation (MAD)	0.61944895
Skewness	1.212285173
Sum	2235.070607
Variance	0.915818113
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11.43882946	1	0.6%
12.56431545	1	0.6%
12.0618229	1	0.6%
15.76061693	1	0.6%
13.39743695	1	0.6%
11.46710112	1	0.6%
12.64968608	1	0.6%
12.56902331	1	0.6%
13.08143149	1	0.6%
12.65799164	1	0.6%
Other values (169)	169	94.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
11.0036187	1	0.6%
11.01668918	1	0.6%
11.0175446	1	0.6%
11.07207412	1	0.6%
11.07708478	1	0.6%

Value	Count	Frequency (%)
16.06159477	1	0.6%
15.98413011	1	0.6%
15.93162896	1	0.6%
15.76061693	1	0.6%
15.12275725	1	0.6%

churnid
Boolean

Distinct	2
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 KiB

0	169
1	10

Common Values
Chart

Value	Count	Frequency (%)
0	169	94.4%
1	10	5.6%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	Cust_id	Age	LocID	GenID	RaceID	PkgID	CusCare_flag	BillCycle_ID	Mean_Mthly_Paid	Total_Bills	Num_of_payments	Timely_full_payments	Delayed_Partial_Payments	Total_Paid_last6mth	Mean_Mthly_Paid_last6mth	Total_Bills_last6mth	Num_Payments_last6mth	Timely_Full_Payments_last6mth	Delayed_Partial_Payments_last6mth	ttl_Data	avg_Data	ttl_Data_last6mth	avg_Data_last6mth	avg_online_days
0	1	35.0	238.0	1	2	227.0	No	6.0	89.07	22	22	18	4	500.75	83.46	6	6	6	0	138033.10	7264.90	826856.47	7253.13	13.344052
1	2	27.0	242.0	2	2	89.0	No	6.0	75.15	28	28	10	18	400.00	66.67	6	6	6	0	112647.36	5928.81	38263.82	6377.30	12.887355
2	3	21.0	242.0	1	1	46.0	No	8.0	85.57	15	15	9	6	502.00	83.67	4	4	4	0	263550.68	20273.13	115426.86	19237.81	12.345485
3	4	58.0	233.0	1	1	227.0	No	6.0	102.56	11	11	9	2	558.90	93.15	5	5	5	0	192596.87	14815.14	1081668.35	13867.54	12.649686
4	5	43.0	231.0	1	1	227.0	No	9.0	102.50	11	11	6	5	564.00	94.00	6	6	4	2	254325.84	23120.53	1418866.28	21497.97	12.633970
5	6	52.0	242.0	1	2	222.0	No	2.0	174.01	6	6	4	2	1044.03	174.01	6	6	4	2	127831.15	25566.23	491679.02	19667.16	13.436630
6	7	49.0	231.0	1	1	227.0	No	9.0	102.85	13	13	6	7	660.00	110.00	7	7	3	4	260268.69	21689.06	1543001.73	21430.58	12.144856
7	8	73.0	231.0	2	1	6.0	No	4.0	79.56	21	21	16	5	418.50	69.75	5	5	5	0	345424.71	15701.12	172961.18	28826.86	12.863905
8	9	31.0	237.0	1	2	43.0	No	4.0	81.12	22	22	17	5	498.70	83.12	7	7	6	1	212347.80	10617.39	88819.68	14803.28	12.679086
9	10	30.0	238.0	2	1	227.0	No	9.0	100.71	12	12	6	6	560.75	93.46	5	5	4	1	143852.43	14385.24	1012437.08	16873.95	13.065960

Last rows

	Cust_id	Age	LocID	GenID	RaceID	PkgID	CusCare_flag	BillCycle_ID	Mean_Mthly_Paid	Total_Bills	Num_of_payments	Timely_full_payments	Delayed_Partial_Payments	Total_Paid_last6mth	Mean_Mthly_Paid_last6mth	Total_Bills_last6mth	Num_Payments_last6mth	Timely_Full_Payments_last6mth	Delayed_Partial_Payments_last6mth	ttl_Data	avg_Data	ttl_Data_last6mth	avg_Data_last6mth	avg_online_days
169	170	43.0	234.0	2	1	9.0	No	4.0	63.88	16	16	8	8	417.45	69.58	7	7	4	3	NaN	4863.09	NaN	3902.41	11.127497
170	171	64.0	242.0	2	4	7.0	No	5.0	107.14	24	24	17	7	623.50	103.92	6	6	5	1	166583.25	6940.97	40679.98	6780.00	12.663290
171	172	38.0	242.0	2	1	168.0	No	8.0	61.02	5	5	4	1	244.08	61.02	5	5	4	1	5065.09	1688.36	2774.37	1387.18	12.119770
172	173	29.0	232.0	1	2	9.0	No	3.0	148.58	12	12	9	3	812.50	135.42	5	5	5	0	131080.47	11916.41	75908.64	12651.44	13.252510
173	174	33.0	234.0	1	2	227.0	No	2.0	114.75	4	4	3	1	459.00	114.75	4	4	3	1	75184.91	25061.64	163757.74	18195.30	11.016689
174	175	48.0	242.0	2	1	216.0	No	7.0	128.91	11	11	8	3	580.00	96.67	5	5	5	0	63906.45	7100.72	51337.89	8556.32	12.951210
175	176	47.0	244.0	1	1	227.0	No	6.0	116.19	9	9	7	2	660.45	110.08	7	7	7	0	159077.69	22725.38	833328.31	19841.15	12.183579
176	177	33.0	232.0	1	1	227.0	No	5.0	100.08	17	17	4	13	566.00	94.33	4	4	4	0	281386.14	25580.56	1288762.95	19526.71	12.860969
177	178	20.0	240.0	2	4	197.0	No	10.0	69.85	5	5	3	2	279.38	69.85	5	5	3	2	22270.12	7423.37	12100.29	6050.15	12.709751
178	179	47.0	238.0	2	2	5.0	No	4.0	52.28	27	27	24	3	305.40	50.90	5	5	4	1	97336.23	3476.29	23700.20	3950.03	11.182745

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows